DBF file insert into oracle table

[rajkumarrv]

how to insert dbf file in oracle9i table using external table concepts

[pozitiv]

how to insert dbf file in oracle9i table using external table concepts

good or not good? that is the ....

CREATE OR REPLACE DIRECTORY
EXT_DIR AS
'c:\TEMP\ext';


GRANT READ, WRITE ON DIRECTORY EXT_DIR TO <USER> WITH GRANT OPTION;


drop table ext_table_fixed;

create table ext_table_fixed (
field_1 char(3),
field_2 char(30)
)
organization external (
type oracle_loader
default directory ext_dir
access parameters (
records delimited by ' '
fields (
field_1 position(1: 3) char( 3),
field_2 position(4:34) char(30)
)
)
location ('file.DBF')
)
reject limit unlimited;


select * from ext_table_fixed;